package com.ljj.mapper;

import com.ljj.pojo.Score;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Delete;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * <p>
 * Mapper 接口
 * </p>
 *
 * @author LJJ
 * @since 2020-07-11
 */
@Repository
public interface ScoreMapper extends BaseMapper<Score> {

    @Delete("delete from score where sid=#{sid} and eid=#{eid}")
    int deleteScore(Score score);

    List<Score> queryScoreBysid(int id);


    Score queryByScore(Score score);

    int updateScore(Score score);
}
